Conversion from star schema of a data warehouse into its equivalent graph multi dimensional data model: A Conceptual Perspective

This paper proposes the design of Star Schema of a Data Warehouse and conversion to its equivalent Graph based Multi Dimensional Data Model (GMDDM Model). Design of Star Schema facilitates in constructing Graph based Multi Dimensional Data Model. The GMDDM model defines a set of graph based constructs that are used to specify the conceptual level design of Data Warehouse. Data warehouse representation is complex itself. Thus the pictorial representation of the Data Warehouse should increase the understandability to the warehouse designer. The warehouse representation through graph G [V, E] may be an effective approach that reduces the inherent complexity of any multi – dimensional data model. But there is no need to develop this model from scratch, rather, in contrast, it may be considered as a software layer on the top of any standard data model representation. Here the scope of the project work is to form a software tool that is able to convert the Star Schema of a Data Warehouse to its equivalent Graph based Multi Dimensional Data Model (GMDDM Model).Hence the software tool helps the warehouse designer to interact with the graph without writing any code and thus ease the entire complex design mechanism. The project work contains a detailed description of the Star Schema of a Data Warehouse say Hospital Management System and conversion from Star Schema to its equivalent Graph based Multi Dimensional Data Model and the conversion rules from StarSchema to its equivalent GMDDM model.